Forum Discussion
Solved
if statement working with dates
I am trying to write an if statement where I have one sheet 2019 and the next sheet 2020 but I keep getting a value error. the following is the formula that I am using: =IF(TEXT(DATE(INT((Dec!H1-1)/1...
If in H1 of Dec sheet you have 01 Dec, 2019 and in H1 of Jan sheet you'd like to have 01 Jan 2010 that could be like
=EDATE(Dec!H1,1)Similar for other sheets.
SergeiBaklan 12/1/2019 is Dec HI
If in H1 of Dec sheet you have 01 Dec, 2019 and in H1 of Jan sheet you'd like to have 01 Jan 2010 that could be like
=EDATE(Dec!H1,1)Similar for other sheets.
works exactly what we wanted thank you SergeiBaklan
wjallen14 , you are welcome
SergeiBaklan I will try and see what happens thank you