Date and Balance Formula

Ileana Stover

Hi there,

I need help creating 2 formulas

1. I am trying to create a formula that takes into account if the Week Ending is a specific date than the balance for that week ending displays accurately.
2. The second formula would essentially be the same if the Week Ending is a specific date what are the number of hours being requested.

I appreciate all of the help

David Tutwiler

I think you're looking for something like:

=IF([Week Ending]@row = DATE(2020, 1, 12), [Balance]@row, 0)

Let me know if that isn't what you were looking for.

Ileana Stover

Hi David,

I tried the formula to see if it's what I needed but it's coming up as #UNPARSEABLE not sure what I would be doing wrong.

David Tutwiler

Try taking the [] off of Balance and just have Balance@row to see if that changes anything.

Ileana Stover

Hi,

I guess I didn't explain myself correctly, what I need is a VLOOKUP formula that will look up the current week ending and provide the balance for that week ending so that I can cell link it to a master sheet. If that makes sense