Today's Date

[ddd2009]

Not sure if there is a solution to this as I have Googled until I cannot Google anymore, any help, advice or just a plane no will be greatly received

I have the formula below which looks at a set date in column H and is based on Today(). However, this is my problem as I need Today() to be fixed at that point in time of processing as my spreadsheet is used over 12 months. Today() is a moveable feast and therefore, my calculations would change over time unless there is an alternative to Today()

=ROUND(IF(H2>=TODAY()-365,0,IF(M2<L2,IF(AD2>SUM(L2*52.143/12)-SUM(M2*52.143/12),SUM(L2*52.143/12)-SUM(M2*52.143/12),IF(M2<L2,IF(AD2<=SUM(L2*52.143/12)-SUM(M2*52.143/12),AD2))),0)),1)

Thank you in advance
Angela

 

[dreid1011]

In formula, no. You would have to manually enter today's date either in the formula or another cell in the row and reference that. Or you could make a macro to perform the calculation when a value is entered into a specific row/column.

 

[ddd2009]

In formula, no. You would have to manually enter today's date either in the formula or another cell in the row and reference that. Or you could make a macro to perform the calculation when a value is entered into a specific row/column.

Thank you, that's what I thought but wanted to get a 2nd opinion, thanks again and back to the drawing board

 

[MARK858]

Similar to what dreid1011 has posted can't you put today's date in a separate cell using Ctrl + ; and reference that?

 

[ddd2009]

Similar to what dreid1011 has posted can't you put today's date in a separate cell using Ctrl + ; and reference that?

Hi, I was trying to get away from adding another column to my extensive spreadsheet, but I think this going to be my easiest option