Is it possible to treat text as a number in excel?

[kskhan]

Dear All,

Is it possible to treat text as a number in excel?
For example while using =if formula can I use Days,Months or other text as number.

[protonLeah]

Provide a better explanation and example. How can the word "Days" be used as a number??

[FDibbins]

Agree that you will find more help if you provide some samples of what you are dealing with.

And depending on how your cell is formatted, Days,Months may in fact already be numbers, if they are real dates

[kskhan]

Thanks for the reply.
Actually I'm preparing a file of daily task against the day using =TOday()formula, Then I have 6 cells with the tasks. Now what I want is to have that specific task on the day using =if(A1=Sunday,Task,"") but getting error on this.
Please find the attached screenshot of the texts & formula I'm trying to use.
I hope that you'll be able to help me now

[jason.b75]

=TODAY returns the date as a number, so you need to get the weekday from it.

=IF(WEEKDAY(A1)=7,"",

Sunday =1, Saturday =7.

If Saturday was actually text then you would have needed to enclose the test string in double inverted commas, =IF(A1="Saturday",""

[boopathiraja]

Hi

Try something this assuming your datevalue in A1

Please Login or Register  to view this content.

[jason.b75]

Hi

Try something this assuming your datevalue in A1

Please Login or Register  to view this content.

CHOOSE would offer more flexibility than LOOKUP

=CHOOSE(WEEKDAY(A1),"","Task-a",Sheet1!B1,etc...