Forum Discussion

Copper Contributor

Apr 20, 2020

Creating a formula when the relevent 'cell' displays differently than its data

In 'column A' I have a formula for example "=sum(A365,1)". The 'category' of the cell is number:custom:DDD giving a visable result of, for example, "Mon". In 'column D' I wish to place a (Logical?)...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Apr 20, 2020

LazyBee

In A366 it could be

=A365+1

and you may check the day of the week by

=WEEKDAY(A366,2)

LazyBee

Copper Contributor

Apr 20, 2020

Ah-ha, thankyou SergeiBaklan ,

I found that =WEEKDAY(A366+1) was necessary, =WEEKDAY(A366,1) gave the same day as A366 and =WEEKDAY(A366,2) gave a result of day earlier, =WEEKDAY(A366,3) gave a result of 2 days earlier! No idea why.

Also making this adjustment in Column A had no effect on getting a favourable result for Column D.

Do you have any recommendations for the Column D formula?

Many thanks

SergeiBaklan
Diamond Contributor
Apr 20, 2020
LazyBee

Could you please submit small sample file with just couple of records, with A365 and A366. It's not clear is that numbers or dates, how they are formatted.