This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,
I am trying to use an IF formula to equal a date but can’t find how to do it.
I want to create IF({WEEK} = “Wk 1”, “15/01/22”
example.
wk 1 = 15/01/22
wk 2 = 23/02/22
Wk 3 = 30/02/22
Does anyone know how to do this?
Thanks
Sorry, yes! The dates I put there are just examples, not real dates.
I am following the financial calendar
wk 1 - 28/06/21 - July
wk 2 - 5/07/21 - July
and so on
I basically just want to be able to select week and then it automatically enters ‘upload...
The formula I am using is correct but I need it to come out as a ‘date’ format but not sure if you can do that within a formula. I run another formula off this cell in a date form, does that make sense?